package com.atguigu.dwm.common.bean;

import lombok.Data;

@Data
public class QueryInfo {

    Long modelId;

    String tableNameQuery;

    String metricName;

    int pageSize=20;

    int pageNo=1;

    public  String getLimitSql(){
        // limit 1 ,20
        // 行号=（ 页号-1 ）* 每页大小
        return  " limit " + (pageNo-1)*pageSize + "," + pageSize;

    }

}
